400 |
How can I display the column using currency format and enlarge the font for certain values
|
399 |
How can I get the number of occurrences of a specified string in the cell
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Columns.Add "" With .Columns.Add("occurrences") .ComputedField = "lower(%0) count 'o'" .FormatColumn = "'contains ' + value + ' of \'o\' chars'" End With With .Items h = .AddItem("Root") .InsertItem h,,"Child 1 oooof the root" .InsertItem h,,"Child 2" .InsertItem h,,"Child 3" .ExpandItem(h) = True End With End With End Function </SCRIPT> </BODY> |
398 |
How can I display dates in my format
|
397 |
How can I display dates in short format
|
396 |
How can I display dates in long format
|
395 |
How can I display only the right part of the cell
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Columns.Add "" With .Columns.Add("Right") .ComputedField = "%0 right 2" .FormatColumn = "'""' + value + '""'" End With With .Items h = .AddItem("Root") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .InsertItem h,,"SChild 3" .ExpandItem(h) = True End With End With End Function </SCRIPT> </BODY> |
394 |
How can I display only the left part of the cell
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Columns.Add "" .Columns.Add("Left").ComputedField = "%0 left 2" With .Items h = .AddItem("Root") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .InsertItem h,,"SChild 3" .ExpandItem(h) = True End With End With End Function </SCRIPT> </BODY> |
393 |
How can I display true or false instead 0 and -1
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Columns.Add("Boolean").FormatColumn = "value != 0 ? 'true' : 'false'" With .Items .AddItem True .AddItem False .AddItem True .AddItem 0 .AddItem 1 End With End With End Function </SCRIPT> </BODY> |
392 |
How can I display icons or images instead numbers
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" With .Columns.Add("Icons") .Def(17) = 1 .FormatColumn = "'The cell displays the icon <img>'+value+'</img> instead ' + value" End With With .Items .AddItem 1 .AddItem 2 .AddItem 3 End With End With End Function </SCRIPT> </BODY> |
391 |
How can I display the column using currency
|
390 |
How can I display the currency only for not empty cells
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Columns.Add "Number" .Columns.Add("Currency").ComputedField = "len(%0) ? currency(dbl(%0)) : ''" With .Items .AddItem "1.23" .AddItem "2.34" .AddItem "0" .ItemBackColor(.AddItem()) = RGB(255,128,128) .AddItem "10000.99" End With End With End Function </SCRIPT> </BODY> |
389 |
Is there a function to display the number of days between two date including the number of hours
|
388 |
Is there a function to display the number of days between two date including the number of hours
|
387 |
How can I display the number of days between two dates
|
386 |
How can I get second part of the date
|
385 |
How can I get minute part of the date
|
384 |
How can I check the hour part only so I know it was afternoon
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .ConditionalFormats.Add("hour(%0)>=12").Bold = True .Columns.Add "Date" .Columns.Add("Hour").ComputedField = "hour(%0)" With .Items .AddItem #1/11/2001 10:00:00 AM# .AddItem #2/22/2002 11:00:00 AM# .AddItem #3/13/2003 0:00:00 PM# .AddItem #4/14/2004 1:00:00 PM# End With End With End Function </SCRIPT> </BODY> |
383 |
What about a function to get the day in the week, or days since Sunday
|
382 |
Is there any function to get the day of the year or number of days since January 1st
|
381 |
How can I display only the day of the date
|
380 |
How can I display only the month of the date
|
379 |
How can I get only the year part from a date expression
|
378 |
Can I convert the expression to date
|
377 |
Can I convert the expression to a number, double or float
|
376 |
How can I display dates in long format
|
375 |
How can I display dates in short format
|
374 |
How can I display the time only of a date expression
|
373 |
Is there any function to display currencies, or money formatted as in the control panel
|
372 |
How can I convert the expression to a string so I can look into the date string expression for month's name
|
371 |
Can I display the absolute value or positive part of the number
|
370 |
Is there any function to get largest number with no fraction part that is not greater than the value
|
369 |
Is there any function to round the values base on the .5 value
|
368 |
How can I get or display the integer part of the cell
|
367 |
How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Columns.Add("").ComputedField = "proper(%0)" With .Items h = .AddItem("root") .InsertItem h,,"child child" .InsertItem h,,"child child" .InsertItem h,,"child child" .ExpandItem(h) = True End With End With End Function </SCRIPT> </BODY> |
366 |
Is there any option to display cells in uppercase
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Columns.Add("").ComputedField = "upper(%0)" With .Items h = .AddItem("Root") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .InsertItem h,,"Chld 3" .ExpandItem(h) = True End With End With End Function </SCRIPT> </BODY> |
365 |
Is there any option to display cells in lowercase
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Columns.Add("").ComputedField = "lower(%0)" With .Items h = .AddItem("Root") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .InsertItem h,,"Chld 3" .ExpandItem(h) = True End With End With End Function </SCRIPT> </BODY> |
364 |
How can I mark the cells that has a specified type, ie strings only
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .ConditionalFormats.Add("type(%0) = 8").ForeColor = RGB(255,0,0) .Columns.Add "" With .Items h = .AddItem("Root") .InsertItem h,,"Child 1" .InsertItem h,,2 .InsertItem h,,"Chld 3" .ExpandItem(h) = True End With End With End Function </SCRIPT> </BODY> |
363 |
How can I bold the items that contains data or those who displays empty strings
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .ConditionalFormats.Add("not len(%1)=0").Bold = True .Columns.Add "C1" .Columns.Add "C2" With .Items h = .AddItem("Root") .InsertItem h,,"Child 1" hC = .InsertItem(h,,"Child 2") .CellCaption(hC,1) = "1" .InsertItem h,,"Child 3" .ExpandItem(h) = True End With End With End Function </SCRIPT> </BODY> |
362 |
Can I change the background color for items or cells that contains a specified string
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .ConditionalFormats.Add("%0 contains 'hi'").BackColor = RGB(255,0,0) .Columns.Add "" With .Items h = .AddItem("Root") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .InsertItem h,,"Chld 3" .ExpandItem(h) = True End With End With End Function </SCRIPT> </BODY> |
361 |
Is there any option to change the fore color for cells or items that ends with a specified string
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .ConditionalFormats.Add("%0 endwith '22'").ForeColor = RGB(255,0,0) .Columns.Add "" With .Items h = .AddItem("Root") .InsertItem h,,"Child 1" .InsertItem h,,"Child 1.22" .InsertItem h,,"Child 2.22" .ExpandItem(h) = True End With End With End Function </SCRIPT> </BODY> |
360 |
How can I highlight the cells or items that starts with a specified string
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .ConditionalFormats.Add("%0 startwith 'C'").Underline = True .Columns.Add "" With .Items h = .AddItem("Root") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .InsertItem h,,"SChild 3" .ExpandItem(h) = True End With End With End Function </SCRIPT> </BODY> |
359 |
How can I change the background color or the visual appearance using ebn for a particular column
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .VisualAppearance.Add 1,"c:\exontrol\images\normal.ebn" With .Columns .Add "Column 1" .Add("Column 2").Def(7) = 16777216 .Add("Column 3").Def(7) = 16777471 .Add "Column 4" End With End With End Function </SCRIPT> </BODY> |
358 |
How can I change the background color for a particular column
|
357 |
Does your control support prompt feature
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" .AutoComplete = False .Columns.Add("Column 1").Prompt = "<img>1</img><i><fgcolor=808080>type to search</fgcolor></i>" .Items.AddItem 0 .Items.AddItem 1 .Items.AddItem 2 End With End Function </SCRIPT> </BODY> |
356 |
How can I display the column's header using multiple lines
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .HeaderHeight = 128 .HeaderSingleLine = False .Columns.Add("This is just a column that should break the header.").Width = 32 .Columns.Add "This is just another column that should break the header." End With End Function </SCRIPT> </BODY> |
355 |
How can I sort the value gets listed in the drop down filter window
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .LinesAtRoot = -1 .MarkSearchColumn = False .Description(0) = "" .Description(1) = "" .Description(2) = "" With .Columns.Add("P1") .DisplayFilterButton = True .DisplayFilterPattern = False .FilterList = 16 End With With .Columns.Add("P2") .DisplayFilterButton = True .DisplayFilterPattern = False .FilterList = 32 End With With .Items h = .AddItem("Z3") .CellCaption(h,1) = "C" .CellCaption(.InsertItem(h,,"Z1"),1) = "B" .CellCaption(.InsertItem(h,,"Z2"),1) = "A" .ExpandItem(h) = True End With End With End Function </SCRIPT> </BODY> |
354 |
Is there any property to disable the popup/context menu being shown when the user does a right click in the control's label area
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Columns.Add("Default").AllowEditContextMenu = False .Items.AddItem 0 .Items.AddItem 1 .Items.AddItem 2 End With End Function </SCRIPT> </BODY> |
353 |
How can I align the text/caption on the scroll bar
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .ScrollPartCaption(1,512) = "left" .ScrollPartCaptionAlignment(1,512) = 0 .ScrollPartCaption(1,128) = "right" .ScrollPartCaptionAlignment(1,128) = 2 .ColumnAutoResize = False .Columns.Add 1 .Columns.Add 2 .Columns.Add 3 .Columns.Add 4 .Columns.Add 5 .Columns.Add 6 End With End Function </SCRIPT> </BODY> |
352 |
Does you control support RTL languages or if there is a property RightToLeft
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .RightToLeft = True .ItemsAllowSizing = -1 .DrawGridLines = 1 .LinesAtRoot = -1 .ScrollBySingleLine = True .DefaultItemHeight = 64 With .Columns.Add("Column") .Alignment = 2 .HeaderAlignment = 2 .EditAlignment = 2 End With With .Items .AddItem "Item 1" .ItemHeight(.InsertItem(.AddItem("Parent"),,"Item 2")) = 48 .AddItem "Item 3" .ExpandItem(.ItemByIndex(1)) = True End With End With End Function </SCRIPT> </BODY> |
351 |
How do I enable resizing all the items at runtime
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .ItemsAllowSizing = 1 .DrawGridLines = 1 .Columns.Add "Column" .Items.AddItem "Item 1" With .Items .ItemHeight(.AddItem("Item 2")) = 48 End With .Items.AddItem "Item 3" End With End Function </SCRIPT> </BODY> |
350 |
How can I remove the filter
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = 1 End With .ApplyFilter .ClearFilter End With End Function </SCRIPT> </BODY> |
349 |
How do I display the icons being selected in the control's label
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" .Columns.Add "Column" With .Items .CellImage(.AddItem("Image 1"),0) = 1 .CellImage(.AddItem("Image 2"),0) = 2 .CellImage(.AddItem("Image 3"),0) = 3 End With .AssignEditImageOnSelect(0) = True .Value = "Image 2" End With End Function </SCRIPT> </BODY> |
348 |
How do I select a value
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .IntegralHeight = True .LinesAtRoot = 1 .TreeColumnIndex = 1 .Columns.Add "Column 1" .Columns.Add "Column 2" With .Items h = .AddItem("Root 1.1") .CellCaption(h,1) = "Root 1.2" .CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" .CellCaption(.InsertItem(h,,"Child 2.1"),1) = "Child 2.2" .ExpandItem(h) = True h = .AddItem("Root 2.1") .CellCaption(h,1) = "Root 2.2" .CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" End With .Value = "Root 1.1" End With End Function </SCRIPT> </BODY> |
347 |
How do I select a value
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .IntegralHeight = True .LinesAtRoot = 1 .TreeColumnIndex = 1 .Columns.Add "Column 1" .Columns.Add "Column 2" With .Items h = .AddItem("Root 1.1") .CellCaption(h,1) = "Root 1.2" .CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" .CellCaption(.InsertItem(h,,"Child 2.1"),1) = "Child 2.2" .ExpandItem(h) = True h = .AddItem("Root 2.1") .CellCaption(h,1) = "Root 2.2" .CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" End With .Select(1) = "Root 1.2" End With End Function </SCRIPT> </BODY> |
346 |
How do change the visual appearance for the drop down border, using EBN
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .VisualAppearance.Add 1,"c:\exontrol\images\normal.ebn" .DropDownBorder = 16777216 ' &H1000000 End With End Function </SCRIPT> </BODY> |
345 |
How do I remove the drop down's border
|
344 |
How can I change the foreground color for edit controls
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .ForeColorEdit = RGB(255,0,0) .IntegralHeight = True .LinesAtRoot = 1 .TreeColumnIndex = 1 .Columns.Add "Column 1" .Columns.Add "Column 2" With .Items h = .AddItem("Root 1.1") .CellCaption(h,1) = "Root 1.2" .CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" .CellCaption(.InsertItem(h,,"Child 2.1"),1) = "Child 2.2" .ExpandItem(h) = True h = .AddItem("Root 2.1") .CellCaption(h,1) = "Root 2.2" .CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" End With .Select(0) = "Root 1.1" End With End Function </SCRIPT> </BODY> |
343 |
How can I change the background color for edit controls
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .BackColorEdit = RGB(255,0,0) .IntegralHeight = True .LinesAtRoot = 1 .TreeColumnIndex = 1 .Columns.Add "Column 1" .Columns.Add "Column 2" With .Items h = .AddItem("Root 1.1") .CellCaption(h,1) = "Root 1.2" .CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" .CellCaption(.InsertItem(h,,"Child 2.1"),1) = "Child 2.2" .ExpandItem(h) = True h = .AddItem("Root 2.1") .CellCaption(h,1) = "Root 2.2" .CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" End With .Select(0) = "Root 1.1" End With End Function </SCRIPT> </BODY> |
342 |
How can I hide the drop down buttons when the control loses the focus
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .HideDropDownButton = True .IntegralHeight = True .LinesAtRoot = 1 .TreeColumnIndex = 1 .Columns.Add "Column 1" .Columns.Add "Column 2" With .Items h = .AddItem("Root 1.1") .CellCaption(h,1) = "Root 1.2" .CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" .CellCaption(.InsertItem(h,,"Child 2.1"),1) = "Child 2.2" .ExpandItem(h) = True h = .AddItem("Root 2.1") .CellCaption(h,1) = "Root 2.2" .CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" End With End With End Function </SCRIPT> </BODY> |
341 |
How can I ensure that the drop down portions doesn't show partial items
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .IntegralHeight = True .LinesAtRoot = 1 .TreeColumnIndex = 1 .Columns.Add "Column 1" .Columns.Add "Column 2" With .Items h = .AddItem("Root 1.1") .CellCaption(h,1) = "Root 1.2" .CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" .CellCaption(.InsertItem(h,,"Child 2.1"),1) = "Child 2.2" .ExpandItem(h) = True h = .AddItem("Root 2.1") .CellCaption(h,1) = "Root 2.2" .CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" End With End With End Function </SCRIPT> </BODY> |
340 |
How can I close the drop down window when user double clicks it
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .CloseOnDblClk = True .LinesAtRoot = 1 .TreeColumnIndex = 1 .Columns.Add "Column 1" .Columns.Add "Column 2" With .Items h = .AddItem("Root 1.1") .CellCaption(h,1) = "Root 1.2" .CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" .CellCaption(.InsertItem(h,,"Child 2.1"),1) = "Child 2.2" .ExpandItem(h) = True h = .AddItem("Root 2.1") .CellCaption(h,1) = "Root 2.2" .CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2" End With End With End Function </SCRIPT> </BODY> |
339 |
How do I get the handle of the drop down window
|
338 |
How do I specify the height of the control's label
|
337 |
The control selects the portion of text that doesn't match with the selected item. How can I avoid that
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .AutoSelect = False .Columns.Add "Column" With .Items .AddItem "Item 3" .AddItem "Item 1" .AddItem "Item 2" End With End With End Function </SCRIPT> </BODY> |
336 |
How can I show the drop down window as soon as user starts typing in the control
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .AutoDropDown = True .Columns.Add "Column" With .Items .AddItem "Item 3" .AddItem "Item 1" .AddItem "Item 2" End With End With End Function </SCRIPT> </BODY> |
335 |
How do I change the text in the edit or label area
|
334 |
How do I lock or make read-only the control
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Locked = True .Columns.Add "Column" With .Items .AddItem "Item 3" .AddItem "Item 1" .AddItem "Item 2" End With End With End Function </SCRIPT> </BODY> |
333 |
How do I let user to resize only the height of the drop down window, at runtime
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .AllowSizeGrip = True .AllowHResize = False .MinWidthList = 100 .MinHeightList = 100 .Columns.Add "Column" With .Items .AddItem "Item 3" .AddItem "Item 1" .AddItem "Item 2" End With End With End Function </SCRIPT> </BODY> |
332 |
How do I let user to resize only the width of the drop down window, at runtime
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .AllowSizeGrip = True .AllowVResize = False .Columns.Add "Column" With .Items .AddItem "Item 3" .AddItem "Item 1" .AddItem "Item 2" End With End With End Function </SCRIPT> </BODY> |
331 |
How do I let user to resize the drop down window, at runtime
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .AllowSizeGrip = True .Columns.Add "Column" With .Items .AddItem "Item 3" .AddItem "Item 1" .AddItem "Item 2" End With End With End Function </SCRIPT> </BODY> |
330 |
How do I specify the height of the drop down window
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .HeightList() = 400 .MinWidthList = 100 .AllowSizeGrip = True .Columns.Add "Column" With .Items .AddItem "Item 3" .AddItem "Item 1" .AddItem "Item 2" End With End With End Function </SCRIPT> </BODY> |
329 |
How do I specify the minimum height of the drop down window
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .MinHeightList = 100 .AllowSizeGrip = True .Columns.Add "Column" With .Items .AddItem "Item 3" .AddItem "Item 1" .AddItem "Item 2" End With End With End Function </SCRIPT> </BODY> |
328 |
How do I specify the width of the drop down window
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .WidthList() = 100 .AllowSizeGrip = True .Columns.Add "Column" With .Items .AddItem "Item 3" .AddItem "Item 1" .AddItem "Item 2" End With End With End Function </SCRIPT> </BODY> |
327 |
How do I specify the minimum width of the drop down window
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .MinWidthList = 100 .AllowSizeGrip = True .Columns.Add "Column" With .Items .AddItem "Item 3" .AddItem "Item 1" .AddItem "Item 2" End With End With End Function </SCRIPT> </BODY> |
326 |
I have multiple columns, how can I display a single edit in the control's label
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .SingleEdit = True .Columns.Add "Column 1" .Columns.Add "Column 2" With .Items .CellCaption(.AddItem("Item 1"),1) = "SubItem 1" .CellCaption(.AddItem("Item 2"),1) = "SubItem 2" .CellCaption(.AddItem("Item 3"),1) = "SubItem 3" End With End With End Function </SCRIPT> </BODY> |
325 |
How do I turn off the auto complete feature
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .AutoComplete = False .Columns.Add "Column" With .Items .AddItem "Item 3" .AddItem "Item 1" .AddItem "Item 2" End With End With End Function </SCRIPT> </BODY> |
324 |
The control supports three styles: Simple, DropDown and DropDownList. How can I change the style
|
323 |
Is there any option to align the header to the left and the data to the right
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Columns.Add("Left").Alignment = 0 With .Columns.Add("Right") .Alignment = 2 .HeaderAlignment = 2 .EditAlignment = 2 End With With .Items .CellCaption(.AddItem("left"),1) = "right" End With End With End Function </SCRIPT> </BODY> |
322 |
How do I change the control's border, using your EBN files
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .VisualAppearance.Add 1,"c:\exontrol\images\normal.ebn" .Appearance = 16777216 ' &H1000000 End With End Function </SCRIPT> </BODY> |
321 |
Can I change the default border of the tooltip, using your EBN files
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .ToolTipDelay = 1 .ToolTipWidth = 364 .VisualAppearance.Add 1,"c:\exontrol\images\normal.ebn" .Background(64) = &H1000000 .Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column" End With End Function </SCRIPT> </BODY> |
320 |
Can I change the background color for the tooltip
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .ToolTipDelay = 1 .ToolTipWidth = 364 .Background(65) = RGB(255,0,0) .Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column" End With End Function </SCRIPT> </BODY> |
319 |
Does the tooltip support HTML format
|
318 |
Can I change the forecolor for the tooltip
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .ToolTipDelay = 1 .ToolTipWidth = 364 .Background(66) = RGB(255,0,0) .Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column" End With End Function </SCRIPT> </BODY> |
317 |
Can I change the foreground color for the tooltip
|
316 |
How can I merge cells
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .DrawGridLines = -1 .MarkSearchColumn = False .Columns.Add "C1" .Columns.Add "C2" .Columns.Add "C3" With .Items h = .AddItem("this cell merges the first two columns") .CellMerge(h,0) = 1 h = .AddItem() .CellCaption(h,1) = "this cell merges the last two columns" .CellMerge(h,1) = 2 h = .AddItem("this cell merges the all three columns") .CellMerge(h,0) = 1 .CellMerge(h,0) = 2 h = .AddItem("this draws a divider item") .ItemDivider(h) = 0 End With End With End Function </SCRIPT> </BODY> |
315 |
How can I merge cells
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .MarkSearchColumn = False .TreeColumnIndex = -1 .Columns.Add "C1" .Columns.Add "C2" With .Items h = .AddItem("Cell 1") .CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." .CellSingleLine(h,1) = False h = .AddItem("This is bit of text merges all cells in the item") .ItemDivider(h) = 0 .CellHAlignment(h,0) = 1 End With End With End Function </SCRIPT> </BODY> |
314 |
How can I change the color for separator / dividers items
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .MarkSearchColumn = False .TreeColumnIndex = -1 .ScrollBySingleLine = False .Columns.Add "C1" .Columns.Add "C2" With .Items h = .AddItem("Cell 1") .CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." .CellSingleLine(h,1) = False h = .AddItem() .ItemDivider(h) = 0 .ItemDividerLine(h) = 4 .ItemDividerLineAlignment(h) = 1 .ItemHeight(h) = 6 .SelectableItem(h) = False h = .AddItem("Cell 2") .CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." .CellSingleLine(h,1) = False End With End With End Function </SCRIPT> </BODY> |
313 |
How can I add separator - dividers items
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .MarkSearchColumn = False .TreeColumnIndex = -1 .ScrollBySingleLine = False .Columns.Add "C1" .Columns.Add "C2" With .Items h = .AddItem("Cell 1") .CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." .CellSingleLine(h,1) = False h = .AddItem() .ItemDivider(h) = 0 .ItemDividerLine(h) = 4 .ItemDividerLineAlignment(h) = 1 .ItemHeight(h) = 6 .SelectableItem(h) = False h = .AddItem("Cell 2") .CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." .CellSingleLine(h,1) = False End With End With End Function </SCRIPT> </BODY> |
312 |
Can I change the style of the line being displayed by a divider item
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .MarkSearchColumn = False .TreeColumnIndex = -1 .ScrollBySingleLine = False .Columns.Add "C1" .Columns.Add "C2" With .Items h = .AddItem("Cell 1") .CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." .CellSingleLine(h,1) = False h = .AddItem("This is bit of text that's displayed on the entire item, divider.") .ItemDivider(h) = 0 .ItemDividerLine(h) = 4 .CellHAlignment(h,0) = 1 .ItemHeight(h) = 24 End With End With End Function </SCRIPT> </BODY> |
311 |
Can I remove the line being displayed by a divider item
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .MarkSearchColumn = False .TreeColumnIndex = -1 .Columns.Add "C1" .Columns.Add "C2" With .Items h = .AddItem("Cell 1") .CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." .CellSingleLine(h,1) = False h = .AddItem("This is bit of text that's displayed on the entire item, divider.") .ItemDivider(h) = 0 .ItemDividerLine(h) = 0 .CellHAlignment(h,0) = 1 End With End With End Function </SCRIPT> </BODY> |
310 |
How can I display a divider item, merging all cells
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .MarkSearchColumn = False .TreeColumnIndex = -1 .Columns.Add "C1" .Columns.Add "C2" With .Items h = .AddItem("Cell 1") .CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." .CellSingleLine(h,1) = False h = .AddItem("This is bit of text that's displayed on the entire item, divider.") .ItemDivider(h) = 0 .CellHAlignment(h,0) = 1 End With End With End Function </SCRIPT> </BODY> |
309 |
How can I fix or lock items
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Columns.Add "Default" With .Items .LockedItemCount(0) = 1 .CellCaption(.LockedItem(0,0),0) = "This is a locked item, fixed to the top side of the control." .ItemBackColor(.LockedItem(0,0)) = RGB(196,196,186) .LockedItemCount(2) = 2 .CellCaption(.LockedItem(2,0),0) = "This is a locked item, fixed to the top side of the control." .ItemBackColor(.LockedItem(2,0)) = RGB(196,196,186) .CellCaption(.LockedItem(2,1),0) = "This is a locked item, fixed to the top side of the control." .ItemBackColor(.LockedItem(2,1)) = RGB(186,186,186) End With End With End Function </SCRIPT> </BODY> |
308 |
How can I fix or lock an item on the bottom side of the control
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Columns.Add "Default" With .Items .LockedItemCount(2) = 1 .CellCaption(.LockedItem(2,0),0) = "This is a locked item, fixed to the bottom side of the control." h = .AddItem("Root 1") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .ExpandItem(h) = True End With End With End Function </SCRIPT> </BODY> |
307 |
How can I fix or lock an item on the top of the control
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Columns.Add "Default" With .Items .LockedItemCount(0) = 1 .CellCaption(.LockedItem(0,0),0) = "This is a locked item, fixed to the top side of the control." h = .AddItem("Root 1") .InsertItem h,,"Child 1" .InsertItem h,,"Child 2" .ExpandItem(h) = True End With End With End Function </SCRIPT> </BODY> |
306 |
Is there any function to limit the height of the items when I display it using multiple lines
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .ScrollBySingleLine = True .Columns.Add "C1" .Columns.Add "C2" With .Items h = .AddItem("Cell 1") .CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines." .CellSingleLine(h,1) = False .ItemMaxHeight(h) = 48 End With End With End Function </SCRIPT> </BODY> |
305 |
Why I cannot center my cells in the column
|
304 |
How can I align the cell to the left, center or to the right
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .TreeColumnIndex = -1 .DrawGridLines = -2 .Columns.Add "Default" With .Items .CellHAlignment(.AddItem("left"),0) = 0 .CellHAlignment(.AddItem("center"),0) = 1 .CellHAlignment(.AddItem("right"),0) = 2 End With End With End Function </SCRIPT> </BODY> |
303 |
How do I apply HTML format to a cell
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .TreeColumnIndex = -1 .Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" .HTMLPicture("p1") = "c:\exontrol\images\zipdisk.gif" .HTMLPicture("p2") = "c:\exontrol\images\auction.gif" .Columns.Add "Default" With .Items h = .AddItem("The following item shows some of the HTML format supported:") .CellHAlignment(h,0) = 1 h = .AddItem("<br>text icons <img>1</img>, <img>2</img>, ... pictures <img>p1</img>, <img>p2</img> <br><br>text <b>bold</b>, <i>italic</i>, <" & _ "u>underline</u>, <s>strikeout</s>, ...<br><dotline>and so on...<br> <a>anchor</a> or <a2>hyperlink</a><br><fgcolor=FF0000>fgcolo" & _ "r</fgcolor> or <bgcolor=00FF00>bgcolor</bgcolor> ") .CellCaptionFormat(h,0) = 1 .CellSingleLine(h,0) = False End With End With End Function </SCRIPT> </BODY> |
302 |
How can I change the font for a cell
|
301 |
How can I change the font for a cell
<BODY onload="Init()"> <OBJECT CLASSID="clsid:CF170E7A-4391-44BD-8D93-29F8D2801EF7" id="ComboBox1"></OBJECT> <SCRIPT LANGUAGE="VBScript"> Function Init() With ComboBox1 .Columns.Add "Default" .Items.AddItem "default font" Set f = CreateObject("StdFont") With f .Name = "Tahoma" .Size = 12 End With With .Items .CellFont(.AddItem("new font"),0) = f End With End With End Function </SCRIPT> </BODY> |